USE [AnotherSuccessfulProcedure]

IF EXISTS (SELECT * FROM sysobjects WHERE id = object_id(N'[dbo].[CapturesInsert]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
BEGIN
	DROP PROCEDURE dbo.CapturesInsert
END


SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		Neil Wilson
-- Create date: 08/29/08
-- Description:	Captures Table Insert
-- =============================================
CREATE PROCEDURE CapturesInsert

			@CaptureId int,
			@CaptureTime datetime,
            @CapName varchar(30),
            @CapNumber int,
            @RoundId int,
            @MiniRoundId int,
            @MapId int,
            @LogId int,
            @TeamId int
	

AS
BEGIN

INSERT INTO [Captures]
           ([CaptureId]
           ,[CaptureTime]
           ,[CapName]
           ,[CapNumber]
           ,[RoundId]
           ,[MiniRoundId]
           ,[MapId]
           ,[LogId]
           ,[TeamId])
     VALUES
           (@CaptureId,
			@CaptureTime,
			@CapName,
			@CapNumber,
			@RoundId,
			@MiniRoundId,
			@MapId,
			@LogId,
			@TeamId
			)

END
GO

